TimeZone

Hi,
There is a request from mgmt, when user browse the request (web), the
database will return the requested timestamp at their timezone that
previously posted. How do i do that? Do I need store whole country codes
together timezones in database mysql ? Is there any way to find full
country code together with their timezone?


Cheers
KH


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: TimeZone

Some countries have multiple timezones, so it is not sufficient to
know the country code in order to get the timezone. If they have
previously posted the timezone, however, then it should be possible to
store that information in a cookie on the client machine that your web
layer can retrieve. If you want to permanently tie a timezone to a
user (assuming that this is an internal system or other system to
which your users authenticate -- if it is a public website you're
going to have to use cookies), simply include an extra column in the
user's record that has a number that stores its differential from GMT
(so the USA east coast would be -5) and save all of your data in GMT,
applying the timezone column to the time via datetime functions either
in the query or in your web layer.

-- Joe

On 8/8/05, KH wrote:
> Hi,
> There is a request from mgmt, when user browse the request (web), the
> database will return the requested timestamp at their timezone that
> previously posted. How do i do that? Do I need store whole country codes
> together timezones in database mysql ? Is there any way to find full
> country code together with their timezone?
>=20
>=20
> Cheers
> KH
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dg.jsciv@gmail.com
>=20
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

Re: TimeZone

Joseph Cochran wrote:
> Some countries have multiple timezones, so it is not sufficient to
> know the country code in order to get the timezone. If they have
> previously posted the timezone, however, then it should be possible to
> store that information in a cookie on the client machine that your web
> layer can retrieve. If you want to permanently tie a timezone to a
> user (assuming that this is an internal system or other system to
> which your users authenticate -- if it is a public website you're
> going to have to use cookies), simply include an extra column in the
> user's record that has a number that stores its differential from GMT
> (so the USA east coast would be -5) and save all of your data in GMT,
> applying the timezone column to the time via datetime functions either
> in the query or in your web layer.

One more complication: daylight savings time are not the same world
wide. So I would store the time zone and not the difference with GMT.

I personally would do al the time zone calculations in the web layer.
Most OSs have libraries with more or less knowledge about daylight
savings in various countries/timezones. Using the functions in the
language of the web layer you're more likely to get things right.

Regards, Jigal.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: timezone

--0016368342d1f7964004a4cb3926
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

Have you populated the timezone tables? Run this query if you are not sure.

*SELECT COUNT(*) FROM mysql.time_zone_name;*
*
*
***If it returns 0 then you need to populate the them as per the
instructions here
http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.htm l*

Default timezone in mysql is set at server startup to SYSTEM, which means s=
o
long as your system clock is correct the MySQL server should be correct.


*
*
On 3 June 2011 09:55, Rocio Gomez Escribano
wrote:

> Hello! I=92m having trouble with timezones.
>
>
>
> I=92m in Spain, we have 2 different timezone now we are in GMT+2, in wint=
er,
> this is the GMT+1.
>
>
>
> I=92m looking for an instruction which give me the current timezone, but =
I
> cant find it! Do you know how can I now it?
>
>
>
> Thanks!
>
>
>
> *Roc=EDo G=F3mez Escribano*
>
> r.gomez@ingenia-soluciones.com
>
>
>
> [image: Descripci=F3n: cid:image002.jpg@01CB8CB6.ADEBA830]
>
> Pol=EDgono Campollano C/F, n=BA21T
>
> 02007 Albacete (Espa=F1a)
>
> Tlf:967-504-513 Fax: 967-504-513
>
> www.ingenia-soluciones.com
>
>
>



--=20
John Daisley

Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer

Telephone: +44 (0)7918 621621
Email: john.daisley@butterflysystems.co.uk

--0016368342d1f7964004a4cb3926--

RE: timezone

------=_NextPart_000_0021_01CC21E1.47AD7510
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0022_01CC21E1.47AD7510"


------=_NextPart_001_0022_01CC21E1.47AD7510
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I=92m afraid I don’’t understand you:

=20

=20

mysql> select count(*) from mysql.time_zone_name;

+----------+

| count(*) |

+----------+

| 0 |

+----------+

1 row in set (0.00 sec)

=20

But, when I execute:

=20

=20

mysql> select now();

+---------------------+

| now() |

+---------------------+

| 2011-06-03 11:28:00 |

+---------------------+

1 row in set (0.00 sec)

=20

That=92s correct, in Spain it=92s that time. So, mysql is using the =
timezone
correctly, isn=92t it?

=20

Thanks!

=20

Roc=EDo G=F3mez Escribano

=
r.gomez@ingenia-soluciones.com

=20

Descripci=F3n: cid:image002.jpg@01CB8CB6.ADEBA830

Pol=EDgono Campollano C/F, n=BA21T

02007 Albacete (Espa=F1a)

Tlf:967-504-513 Fax: 967-504-513

www.ingenia-soluciones.com

=20

De: John Daisley [mailto:daisleyjohn@googlemail.com]=20
Enviado el: viernes, 03 de junio de 2011 11:18
Para: Rocio Gomez Escribano
CC: mysql@lists.mysql.com
Asunto: Re: timezone

=20

Have you populated the timezone tables? Run this query if you are not =
sure.

=20

SELECT COUNT(*) FROM mysql.time_zone_name;

=20

If it returns 0 then you need to populate the them as per the =
instructions
here http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.htm l

=20

Default timezone in mysql is set at server startup to SYSTEM, which =
means so
long as your system clock is correct the MySQL server should be correct.

=20

=20

=20

On 3 June 2011 09:55, Rocio Gomez Escribano =

wrote:

Hello! I=92m having trouble with timezones.

=20

I=92m in Spain, we have 2 different timezone now we are in GMT+2, in =
winter,
this is the GMT+1.

=20

I=92m looking for an instruction which give me the current timezone, but =
I
cant find it! Do you know how can I now it?

=20

Thanks!

=20

Roc=EDo G=F3mez Escribano

r.gomez@ingenia-soluciones.com =


=20

=A1Error! Nombre de archivo no especificado.

Pol=EDgono Campollano C/F, n=BA21T

02007 Albacete (Espa=F1a)

Tlf:967-504-513 Fax: 967-504-513

www.ingenia-soluciones.com

=20




--=20
John Daisley

Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer

Telephone: +44 (0)7918 621621
Email: john.daisley@butterflysystems.co.uk


------=_NextPart_001_0022_01CC21E1.47AD7510
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

charset=3Diso-8859-1">
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40"> content=3D"Microsoft Word 12 (filtered medium)"> vlink=3Dpurple>